package com.panda.web.mapper.wechatinfo;

import com.panda.web.entity.wechatinfo.WechatUserinfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 用户个人信息Mapper接口
 * 
 * @author cpanda
 * @date 2025-03-04
 */
@Mapper
public interface WechatUserinfoMapper extends BaseMapper<WechatUserinfo> {

//    @Select("select * from wechat_userinfo where openid=#{openid}")
//    WechatUserinfo findByOpenid(String openid);
    @Select("select * from wechat_userinfo where openid=#{openid}")
    WechatUserinfo findByOpenid(String openid);
    @Select("select userinfo_id,screen_number from wechat_userinfo ")
    List<WechatUserinfo> findBySelectList();
}
